<?
session_start();
include('conn.php');
	$date=$_REQUEST['trndate'];
	$day= substr($date,0,2);
	$month = substr($date,3,2);
	$year = substr($date,6,4);
	$trndate=$year.'-'.$month.'-'.$day;
	$business=$_REQUEST['business'];
	$Sub_category=$_REQUEST['Sub_category'];
	$Dist_Name=$_REQUEST['Dist_Name'];
	$Sub_delear=$_REQUEST['Sub_delear'];
	$Dr_Amount=$_REQUEST['Dr_Amount'];
	$Cr_Amount=$_REQUEST['Cr_Amount'];
	$Bank=$_REQUEST['Bank'];
	$Branch=$_REQUEST['Branch'];
$qry1 = "insert into  transactionmast1(trndate,business,category,customer,subdealer,debitamt,creditamt,bankname,branchname,enteredby,entrydt)
			values('".$trndate."','".$business."','".$Sub_category."','".$Dist_Name."','".$Sub_delear."','".$Dr_Amount."','".$Cr_Amount."','".$Bank."','".$Branch."','admin',sysdate())";

$qry = mysql_query($qry1);
//echo $qry1;
?>
